2013-05-29 - 5579.600 - Rel Notes - ELT Reports (Service Level Report) - Release 001 #BIReleases2013
Release Notes:
4674.1200 - BI Reports Issues - DSCO100
Admin Info
Purpose
|
Design and development of Service level report.
|
Release No
|
001
|
Submitted
|
05-29-2013
|
Submitted by
|
Praveen Guntuka
|
Source/Destination Systems
|
IT > BMS > Quality to IT > BMS > Production in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Mallareddy D
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
Service Level Report
BEx Query and MS Excel sheet(s)Used
ZSDC_SSL_Q009
Customer Group.xls
License group.xls
Silhouette Group.xls
Customer Group.xls
NEC Crystal Reports Standards Check
1. SSL has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SSL NEC CR checklist has been sent to NEC and also attached here for reference:
Summary Level Check
Test Conducted
Level : CORPORATE
SNo
|
Test Case
|
Value in BEx Query
|
Value in Crystal Report
|
Pass/Fail
|
1
|
Fill Rate - Ordered TY
|
95.6834
|
95.6834
|
Pass
|
2
|
Fill Rate - Ordered LY
|
95.9631
|
95.9631
|
Pass
|
3
|
Fill Rate - Confirmed TY
|
99.7283
|
99.7283
|
Pass
|
4
|
Fill Rate - Confirmed LY
|
99.7394
|
99.7394
|
Pass
|
5
|
Fill Rate - Ordered TYM
|
96.9717
|
96.9717
|
Pass
|
6
|
Fill Rate - Ordered LYM
|
97.5293
|
97.5293
|
Pass
|
7
|
Fill Rate - Confirmed TYM
|
99.6274
|
99.6274
|
Pass
|
8
|
Fill Rate - Confirmed LYM
|
99.7525
|
99.7525
|
Pass
|
9
|
Ontime - Ordered TY
|
82.4741
|
82.4741
|
Pass
|
10
|
Ontime - Ordered LY
|
82.2245
|
82.2245
|
Pass
|
11
|
Ontime - Confirmed TY
|
90.3589
|
90.3589
|
Pass
|
12
|
Ontime - Confirmed LY
|
92.2063
|
92.2063
|
Pass
|
13
|
Ontime - Ordered TYM
|
-
|
-
|
Pass
|
14
|
Ontime - Ordered LYM
|
81.1219
|
81.1219
|
Pass
|
15
|
Ontime - Confirmed TYM
|
95.1826
|
95.1826
|
Pass
|
16
|
Ontime - Confirmed LYM
|
90.3782
|
90.3782
|
Pass
|
17
|
First Pass - Confirmed TY
|
94.6542
|
94.6542
|
Pass
|
18
|
First Pass - Confirmed LY
|
97.5345
|
97.5345
|
Pass
|
19
|
First Pass - Confirmed TYM
|
96.1293
|
96.1293
|
Pass
|
20
|
First Pass - Confirmed LYM
|
96.5507
|
96.5507
|
Pass
|
Level : North America
SNo
|
Test Case
|
Value in BEx Query
|
Value in Crystal Report
|
Pass/Fail
|
1
|
Fill Rate - Ordered TY
|
95.5375
|
95.5375
|
Pass
|
2
|
Fill Rate - Ordered LY
|
96.0720
|
96.0720
|
Pass
|
3
|
Fill Rate - Confirmed TY
|
99.7231
|
99.7231
|
Pass
|
4
|
Fill Rate - Confirmed LY
|
99.7280
|
99.7280
|
Pass
|
5
|
Fill Rate - Ordered TYM
|
97.2331
|
97.2331
|
Pass
|
6
|
Fill Rate - Ordered LYM
|
97.5205
|
97.5205
|
Pass
|
7
|
Fill Rate - Confirmed TYM
|
99.6124
|
99.6124
|
Pass
|
8
|
Fill Rate - Confirmed LYM
|
99.7398
|
99.7398
|
Pass
|
9
|
Ontime - Ordered TY
|
82.8923
|
82.8923
|
Pass
|
10
|
Ontime - Ordered LY
|
82.4862
|
82.4862
|
Pass
|
11
|
Ontime - Confirmed TY
|
91.7541
|
91.7541
|
Pass
|
12
|
Ontime - Confirmed LY
|
93.4085
|
93.4085
|
Pass
|
13
|
Ontime - Ordered TYM
|
-
|
-
|
Pass
|
14
|
Ontime - Ordered LYM
|
80.2469
|
80.2469
|
Pass
|
15
|
Ontime - Confirmed TYM
|
96.2176
|
96.2176
|
Pass
|
16
|
Ontime - Confirmed LYM
|
90.6094
|
90.6094
|
Pass
|
17
|
First Pass - Confirmed TY
|
94.1511
|
94.1511
|
Pass
|
18
|
First Pass - Confirmed LY
|
97.3942
|
97.3942
|
Pass
|
19
|
First Pass - Confirmed TYM
|
95.6138
|
95.6138
|
Pass
|
20
|
First Pass - Confirmed LYM
|
96.1153
|
96.1153
|
Pass
|
Level : Emerging Markets
SNo
|
Test Case
|
Value in BEx Query
|
Value in Crystal Report
|
Pass/Fail
|
1
|
Fill Rate - Ordered TY
|
88.1257
|
88.1257
|
Pass
|
2
|
Fill Rate - Ordered LY
|
75.7361
|
75.7361
|
Pass
|
3
|
Fill Rate - Confirmed TY
|
99.4968
|
99.4968
|
Pass
|
4
|
Fill Rate - Confirmed LY
|
99.7969
|
99.7969
|
Pass
|
5
|
Fill Rate - Ordered TYM
|
76.1278
|
76.1278
|
Pass
|
6
|
Fill Rate - Ordered LYM
|
90.1455
|
90.1455
|
Pass
|
7
|
Fill Rate - Confirmed TYM
|
98.9426
|
98.9426
|
Pass
|
8
|
Fill Rate - Confirmed LYM
|
99.7464
|
99.7464
|
Pass
|
9
|
Ontime - Ordered TY
|
76.7943
|
76.7943
|
Pass
|
10
|
Ontime - Ordered LY
|
76.9226
|
76.9226
|
Pass
|
11
|
Ontime - Confirmed TY
|
82.9621
|
82.9621
|
Pass
|
12
|
Ontime - Confirmed LY
|
82.8040
|
82.8040
|
Pass
|
13
|
Ontime - Ordered TYM
|
-
|
-
|
Pass
|
14
|
Ontime - Ordered LYM
|
80.2041
|
80.2041
|
Pass
|
15
|
Ontime - Confirmed TYM
|
96.7612
|
96.7612
|
Pass
|
16
|
Ontime - Confirmed LYM
|
90.6749
|
90.6749
|
Pass
|
17
|
First Pass - Confirmed TY
|
94.3272
|
94.3272
|
Pass
|
18
|
First Pass - Confirmed LY
|
98.8243
|
98.8243
|
Pass
|
19
|
First Pass - Confirmed TYM
|
97.6543
|
97.6543
|
Pass
|
20
|
First Pass - Confirmed LYM
|
99.0195
|
99.0195
|
Pass
|
Level : EMEA
SNo
|
Test Case
|
Value in BEx Query
|
Value in Crystal Report
|
Pass/Fail
|
1
|
Fill Rate - Ordered TY
|
98.6745
|
98.6745
|
Pass
|
2
|
Fill Rate - Ordered LY
|
98.2655
|
98.2655
|
Pass
|
3
|
Fill Rate - Confirmed TY
|
99.8177
|
99.8177
|
Pass
|
4
|
Fill Rate - Confirmed LY
|
99.8101
|
99.8101
|
Pass
|
5
|
Fill Rate - Ordered TYM
|
99.2234
|
99.2234
|
Pass
|
6
|
Fill Rate - Ordered LYM
|
98.2543
|
98.2543
|
Pass
|
7
|
Fill Rate - Confirmed TYM
|
99.8413
|
99.8413
|
Pass
|
8
|
Fill Rate - Confirmed LYM
|
99.8518
|
99.8518
|
Pass
|
9
|
Ontime - Ordered TY
|
80.6157
|
80.6157
|
Pass
|
10
|
Ontime - Ordered LY
|
81.0547
|
81.0547
|
Pass
|
11
|
Ontime - Confirmed TY
|
81.6065
|
81.6065
|
Pass
|
12
|
Ontime - Confirmed LY
|
85.0869
|
85.0869
|
Pass
|
13
|
Ontime - Ordered TYM
|
-
|
-
|
Pass
|
14
|
Ontime - Ordered LYM
|
87.9840
|
87.9840
|
Pass
|
15
|
Ontime - Confirmed TYM
|
87.5018
|
87.5018
|
Pass
|
16
|
Ontime - Confirmed LYM
|
88.5607
|
88.5607
|
Pass
|
17
|
First Pass - Confirmed TY
|
98.4747
|
98.4747
|
Pass
|
18
|
First Pass - Confirmed LY
|
98.3436
|
98.3436
|
Pass
|
19
|
First Pass - Confirmed TYM
|
99.6072
|
99.6072
|
Pass
|
20
|
First Pass - Confirmed LYM
|
99.7300
|
99.7300
|
Pass
|
Reference Document(Specification)
2013-01-10- 5579.600 - Spec - ELT Reports (Service Level Report)